SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE GetUserByEmail
	@Email	nvarchar(320)
AS
BEGIN
	SELECT TOP 1 UserId, Email, Password, Username, IsDeleted, Created FROM Users WHERE Email = @Email AND IsDeleted = 0 ORDER BY Created DESC
END
GO
